*Table 3


use "Data_ImportantProvisions_240423.dta", clear
keep lab mean_general cat1 
replace mean_general = round(mean_general, 0.01)
keep if mean_general > 3.99

gen category_number = ""
replace category_number = "(1)" if cat1 == "Rights and Duties"
replace category_number = "(2)" if cat1 == "Judiciary"
replace category_number = "(3)" if cat1 == "Legislature"
replace category_number = "(4)" if cat1 == "Executive"
replace category_number = "(5)" if cat1 == "Principle and Symbols"
replace category_number = "(6)" if cat1 == "Elections"
replace category_number = "(7)" if cat1 == "Culture and Identity"
replace category_number = "(8)" if cat1 == "Regulation and Oversight"
replace category_number = "(9)" if cat1 == "International Law"
replace category_number = "(10)" if cat1 == "Federalism"
replace category_number = "(11)" if cat1 == "Special Sections"
replace category_number = "(12)" if cat1 == "Amendment"




ren lab Provision
ren mean_general Mean_Importance
ren category_number Category

gsort -Mean_Importance
br

export excel using "Table_3.xlsx", replace
